﻿CREATE TABLE [dbo].[RecursoPregunta] (
    [IdPregunta] INT NOT NULL,
    [IdRecurso]  INT NOT NULL,
    CONSTRAINT [PK_RecursoPregunta] PRIMARY KEY CLUSTERED ([IdPregunta] ASC, [IdRecurso] ASC),
    CONSTRAINT [FK_RecursoPregunta_Pregunta] FOREIGN KEY ([IdPregunta]) REFERENCES [dbo].[Pregunta] ([IdPregunta]),
    CONSTRAINT [FK_RecursoPregunta_Recurso] FOREIGN KEY ([IdRecurso]) REFERENCES [dbo].[Recurso] ([IdRecurso])
);

